---:GREETZ:------------------------------------------------------------ Greetings! Below is a micro-summary of the files in the AutoRexx plugIn range. All AutoRexx PlugIns are copyrighted by the Author stated in each entry. You are welcome to modify the code to suit your own setup, but if you use it to build another plug-in, please send me a copy with microdox at a minimum please, and I'll include it in the archive with your permission. If you would prefer I not distribute it, please state so CLEARLY, otherwise permission WILL BE ASSUMED. ---:BLURB:------------------------------------------------------------- I started using DB and found it to be a bitch to get the hang of. Internal editing was bitchy-hard without any real GUI builder (see note.1) and the output file was confusing to say the least. Since there seems to be no real structure to the RFF, it's flexible, but annoying. So, with a peek through the samples, and what dox there are, and some good pointers from a friend who introduced me to DB, I started building the AutoRexx range of DB PlugIns. Note.1: I love DB, don't get me wrong, it's just no where near finished, and thus is still a mess to use internally, and confusing manually. There is, as yet, no really effective internal designer, so we still have to play manually. Anyways, if you like, please use. A note to say 'Howdee' would be nice, but not required.If you alter, please don't remove any of my copyright notes. Fair's fair, y'know. If you use as a basis for new AutoRexx plugIns, please send me a copy, as requested above. Karl Mottram - karl@bifrost.manawatu.gen.nz - 19961228 23:30:00 Now, on to the MicroDox... ---:MICRODOX FORMAT:--------------------------------------------------- - - Auth: Code author - code is copyrighted by this person. Args: Args to pass it on invocation. C= standard / please. Func: Quick function summary. Incl: Sample entry, with syntax. NAME= -> NEXT= please. Note: Any notes the author wants pointed out. Head: ---:MICRODOX:------------------------------------------------- - XportSumm.rexx - Collects, collates and writes summary data. Auth: Karl Mottram Args: None Func: To automate a summary system for fiscal accounting. Incl: NAME=Su_mmarised,FTYP=checkbox,OFFS=10,SIZE=2,AUTORXFILE="DB:Rexx/XportSumm.rexx",NEXT=nl Note: Output file may not be suitable, feel free to modify/junk this. Head: JNum Client Date Amount QTY File Desc Paid PDate Costs Summ Trigger @RFF=1.1,TYPE=internal,CMNT="AutoRexx PlugIns © 1996 Karl Mottram - Teknofile Services",RXPORTNAME=TFJOB FLEN=800 @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=QuickScan NAME="Job #",OFFS=0,SIZE=5,NEXT=tab NAME=Paid,OFFS=7,SIZE=2,NEXT=space NAME=Summ,OFFS=10,SIZE=2,NEXT=nl NAME=Client,OFFS=1,SIZE=27,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=3,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=nl @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=FullScan NAME="Job _#",OFFS=0,SIZE=7,AUTORXFILE=DB:PlugIns/AIClient.rexx,NEXT=tab NAME="Job _Date",OFFS=2,SIZE=10,NEXT=tab NAME=_Paid,FTYP=checkbox,OFFS=7,SIZE=2,AUTORXFILE="DB:PlugIns/AddDate.rexx Paid PDate",NEXT=space NAME=on,FTYP=text,OFFS=8,SIZE=9,NEXT=nl NAME=_Client,OFFS=1,SIZE=30,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=8,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=space NAME=Su_mmarised,FTYP=checkbox,OFFS=10,SIZE=2,AUTORXFILE="DB:Rexx/XportSumm.rexx",NEXT=nl NAME=_File(s,OFFS=5,SIZE=57,NEXT=para NAME="_Amount $",OFFS=3,SIZE=23,NEXT=space NAME="Costs _$",OFFS=9,SIZE=23,NEXT=para NAME=_Qty,OFFS=4,SIZE=8,NEXT=nl NAME=Desc,FTYP=textfield,ROWS=5,OFFS=6,SIZE=57,NEXT=nl - AddDate.rexx - DB PlugIn : Auto-Insert current date into DB field. Auth: Karl Mottram Args: TagField/S OutField/S Func: Auto-insert current date into target DB database. Incl: NAME=_Paid,FTYP=checkbox,OFFS=7,SIZE=2,AUTORXFILE="DB:PlugIns/AddDate.rexx Paid PDate",NEXT=nl Note: Could be launched from Trigger.rexx if you removed TagField code. Head: JNum Client Date Amount QTY File Desc Paid PDate Costs Summ Trigger @RFF=1.1,TYPE=internal,CMNT="AutoRexx PlugIns © 1996 Karl Mottram - Teknofile Services",RXPORTNAME=TFJOB FLEN=800 @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=QuickScan NAME="Job #",OFFS=0,SIZE=5,NEXT=tab NAME=Paid,OFFS=7,SIZE=2,NEXT=space NAME=Summ,OFFS=10,SIZE=2,NEXT=nl NAME=Client,OFFS=1,SIZE=27,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=3,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=nl @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=FullScan NAME="Job _#",OFFS=0,SIZE=7,AUTORXFILE=DB:PlugIns/AIClient.rexx,NEXT=tab NAME="Job _Date",OFFS=2,SIZE=10,NEXT=tab NAME=_Paid,FTYP=checkbox,OFFS=7,SIZE=2,AUTORXFILE="DB:PlugIns/AddDate.rexx Paid PDate",NEXT=space NAME=on,FTYP=text,OFFS=8,SIZE=9,NEXT=nl NAME=_Client,OFFS=1,SIZE=30,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=8,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=space NAME=Su_mmarised,FTYP=checkbox,OFFS=10,SIZE=2,AUTORXFILE="DB:Rexx/XportSumm.rexx",NEXT=nl NAME=_File(s,OFFS=5,SIZE=57,NEXT=para NAME="_Amount $",OFFS=3,SIZE=23,NEXT=space NAME="Costs _$",OFFS=9,SIZE=23,NEXT=para NAME=_Qty,OFFS=4,SIZE=8,NEXT=nl NAME=Desc,FTYP=textfield,ROWS=5,OFFS=6,SIZE=57,NEXT=nl - AIClient.rexx - DB PlugIn : Auto-Insert Client name into database Auth: Karl Mottram Args: None Func: Checks in list, and inserts applicable label Incl: NAME="Job _#",OFFS=0,SIZE=7,AUTORXFILE=DB:PlugIns/AIClient.rexx,NEXT=nl Note: Edit script file paths for custom usage. Head: JNum Client Date Amount QTY File Desc Paid PDate Costs Summ Trigger @RFF=1.1,TYPE=internal,CMNT="AutoRexx PlugIns © 1996 Karl Mottram - Teknofile Services",RXPORTNAME=TFJOB FLEN=800 @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=QuickScan NAME="Job #",OFFS=0,SIZE=5,NEXT=tab NAME=Paid,OFFS=7,SIZE=2,NEXT=space NAME=Summ,OFFS=10,SIZE=2,NEXT=nl NAME=Client,OFFS=1,SIZE=27,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=3,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=nl @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=FullScan NAME="Job _#",OFFS=0,SIZE=7,AUTORXFILE=DB:PlugIns/AIClient.rexx,NEXT=tab NAME="Job _Date",OFFS=2,SIZE=10,NEXT=tab NAME=_Paid,FTYP=checkbox,OFFS=7,SIZE=2,AUTORXFILE="DB:PlugIns/AddDate.rexx Paid PDate",NEXT=space NAME=on,FTYP=text,OFFS=8,SIZE=9,NEXT=nl NAME=_Client,OFFS=1,SIZE=30,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=8,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=space NAME=Su_mmarised,FTYP=checkbox,OFFS=10,SIZE=2,AUTORXFILE="DB:Rexx/XportSumm.rexx",NEXT=nl NAME=_File(s,OFFS=5,SIZE=57,NEXT=para NAME="_Amount $",OFFS=3,SIZE=23,NEXT=space NAME="Costs _$",OFFS=9,SIZE=23,NEXT=para NAME=_Qty,OFFS=4,SIZE=8,NEXT=nl NAME=Desc,FTYP=textfield,ROWS=5,OFFS=6,SIZE=57,NEXT=nl - GetClient.rexx - DB PlugIn : Sets DB to start of Client entries Auth: Karl Mottram Args: CDat/S Flag/S Func: Searches database for search-string, and sets CURRENTRECORD to entry Incl: Best set to run from within Trigger environment. Note: See code for acceptable FLAG args and functions derived. Head: JNum Client Date Amount QTY File Desc Paid PDate Costs Summ Trigger @RFF=1.1,TYPE=internal,CMNT="AutoRexx PlugIns © 1996 Karl Mottram - Teknofile Services",RXPORTNAME=TFJOB FLEN=800 @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=QuickScan NAME="Job #",OFFS=0,SIZE=5,NEXT=tab NAME=Paid,OFFS=7,SIZE=2,NEXT=space NAME=Summ,OFFS=10,SIZE=2,NEXT=nl NAME=Client,OFFS=1,SIZE=27,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=3,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=nl @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=FullScan NAME="Job _#",OFFS=0,SIZE=7,AUTORXFILE=DB:PlugIns/AIClient.rexx,NEXT=tab NAME="Job _Date",OFFS=2,SIZE=10,NEXT=tab NAME=_Paid,FTYP=checkbox,OFFS=7,SIZE=2,AUTORXFILE="DB:PlugIns/AddDate.rexx Paid PDate",NEXT=space NAME=on,FTYP=text,OFFS=8,SIZE=9,NEXT=nl NAME=_Client,OFFS=1,SIZE=30,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=8,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=space NAME=Su_mmarised,FTYP=checkbox,OFFS=10,SIZE=2,AUTORXFILE="DB:Rexx/XportSumm.rexx",NEXT=nl NAME=_File(s,OFFS=5,SIZE=57,NEXT=para NAME="_Amount $",OFFS=3,SIZE=23,NEXT=space NAME="Costs _$",OFFS=9,SIZE=23,NEXT=para NAME=_Qty,OFFS=4,SIZE=8,NEXT=nl NAME=Desc,FTYP=textfield,ROWS=5,OFFS=6,SIZE=57,NEXT=nl - Trigger.rexx - DB PlugIn : A simple trigger to tag checkboxes Auth: Karl Mottram Args: PlugIn/S Func: Simple dumb-trigger which resets itself. Incl: NAME="",FTYP=checkbox,OFFS=11,SIZE=8,AUTORXFILE="DB:PlugIns/Trigger.rexx ",NEXT=nl Note: Handy for tagging checkboxes mainly. Head: JNum Client Date Amount QTY File Desc Paid PDate Costs Summ Trigger @RFF=1.1,TYPE=internal,CMNT="AutoRexx PlugIns © 1996 Karl Mottram - Teknofile Services",RXPORTNAME=TFJOB FLEN=800 @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=QuickScan NAME="Job #",OFFS=0,SIZE=5,NEXT=tab NAME=Paid,OFFS=7,SIZE=2,NEXT=space NAME=Summ,OFFS=10,SIZE=2,NEXT=nl NAME=Client,OFFS=1,SIZE=27,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=3,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=nl @RFF=1.1,TYPE=form,TABSIZE=10,LNAM=FullScan NAME="Job _#",OFFS=0,SIZE=7,AUTORXFILE=DB:PlugIns/AIClient.rexx,NEXT=tab NAME="Job _Date",OFFS=2,SIZE=10,NEXT=tab NAME=_Paid,FTYP=checkbox,OFFS=7,SIZE=2,AUTORXFILE="DB:PlugIns/AddDate.rexx Paid PDate",NEXT=space NAME=on,FTYP=text,OFFS=8,SIZE=9,NEXT=nl NAME=_Client,OFFS=1,SIZE=30,NEXT=space NAME="",FTYP=checkbox,OFFS=11,SIZE=8,AUTORXFILE="DB:PlugIns/Trigger.rexx GetClient.rexx x -p",NEXT=space NAME=Su_mmarised,FTYP=checkbox,OFFS=10,SIZE=2,AUTORXFILE="DB:Rexx/XportSumm.rexx",NEXT=nl NAME=_File(s,OFFS=5,SIZE=57,NEXT=para NAME="_Amount $",OFFS=3,SIZE=23,NEXT=space NAME="Costs _$",OFFS=9,SIZE=23,NEXT=para NAME=_Qty,OFFS=4,SIZE=8,NEXT=nl NAME=Desc,FTYP=textfield,ROWS=5,OFFS=6,SIZE=57,NEXT=nl